# list = [0,1,2,3,4,5,6,7,8,9,10]
# cols_list= locals()
# cols_list['cols_list_' + str(1)] = [0,1,2,3,4,5,6,7,8,9,10]
# del cols_list['cols_list_' + str(1)][0:3]
# print(cols_list['cols_list_' + str(1)])

# import inspect
# def get_variable_name(variable):
#   callers_local_vars = inspect.currentframe().f_back.f_locals.items()
#   return [var_name for var_name, var_val in callers_local_vars if var_val is variable]
#
# if __name__ == '__main__':
#   prepare_list = locals()
#   for i in range(16):
#     prepare_list['list_' + str(i)] = []
#     prepare_list['list_' + str(i)].append(('我是第' + str(i)) + '个list')
#   a = get_variable_name(prepare_list['list_0']).pop()
#   b = get_variable_name(prepare_list['list_1']).pop()
#   print(a)
#   print(b)
from openpyxl.styles import Border, Side, PatternFill, Font, GradientFill, Alignment
from openpyxl import Workbook
from openpyxl.styles import Font
from copy import copy
import xlrd
import xlwt
import openpyxl
import sys
import xlsxwriter
from openpyxl.utils import get_column_letter
from openpyxl import Workbook
import inspect
from openpyxl.styles import Border, Side, colors
from openpyxl.styles import Alignment
import os
# ft1 = Font(name='Arial', size=14)
# ft3 = Font(name='Arial', size=24)
# ft2 = copy(ft1)
# ft2.name = "Tahoma"
# ft1.name
# print(ft1.name)
# print(ft3.name)
# ft2.name
# ft2.size
#
#
# def style_range(ws, cell_range, border=Border(), fill=None, font=None, alignment=None):
#
#   top = Border(top=border.top)
#   left = Border(left=border.left)
#   right = Border(right=border.right)
#   bottom = Border(bottom=border.bottom)

file = 'test2.xlsx'
workbook = xlrd.open_workbook(file)  # 创建工作空间
sheet1 = workbook.sheet_by_index(0)  # 选取第0个表

workbook2 = openpyxl.load_workbook(file)  # 创建工作空间
sheet2 = workbook2['Sheet1']  # 选取Sheet1表

print(sheet2.cell(11,22).value)
len(sheet2.cell(11,22).value)
print(len(sheet2.cell(11,22).value))